Forum

Notifications
Clear all

Data transformation spell checking words in middle of concatenated string?

4 Posts
2 Users
0 Reactions
70 Views
(@cairnsy)
Posts: 6
Active Member
Topic starter
 

Hi,

We have 100’s of 1,000’s of Drawings in a bespoke database that’s going to be ported to a more modern CAD PDM system.

Would like to concatenate 2 x 61 letter fields (Doc Name1 & Doc Name 2) into one, which is easy enough, HOWEVER, some words that didn’t fit between fields have simply been wrapped into both fields.

SOME records take up the full 61 characters in the first field, and the second field is the2nd line, requiring a space to be added.

Oh, and words maybe abbreviated, &/or colloquial words too!

Examples outlined red in attached file.

 

Is there a way to concatenate, reverse search a space and check if the next “word” is “actually a word” (in a custom dictionary)?

I’m thinking of a staged process, adding flags to a new “status” field and using a special setup Spell check dictionary to check against (adding colloquial words as required).

Exporting to Excel took days & weeks of batch downloads before collating into one spreadsheet.

Power BI seems powerful enough, but unsure if it can spell check data

 

Oh, and final output needs to be xml tagged too.

 

Any help would be appreciated.

 
Posted : 20/10/2022 6:47 am
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

Hi Ian,

No file is attached.  You have to click Start Upload after selecting the file(s).

Please supply an example of the result you are after, demonstrating what you mean by XML tagged.

Regards

Phil

 
Posted : 20/10/2022 7:24 pm
(@cairnsy)
Posts: 6
Active Member
Topic starter
 

Sorry, wondered about that, thanks Phil

 

2022-10-19-Data-transformation-word-wrap-examples.jpg

 
Posted : 21/10/2022 3:10 am
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

Hi Ian,

Have you got an actual Excel file?  That image is small and I can't read it to understand what the issue is or the results you want.

You haven't demonstrated the result you want, including the XML tagging you refer to.

regards

Phil

 
Posted : 21/10/2022 5:40 pm
Share: