Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am bringing in an excel document that I want to touch as little as possible but one of the cells has wrapped text in it and I don't know how to get rid of the extra letters it causes.
I am just guessing, but you probably want to remove some special characters like a LF character, so maybe try
LOAD
FIELD,
Purgechar(FIELD, chr(10)&chr(13) ) as FIELD_PURGED,
...
FROM ...;
You can use Keepchar() to keep only characters you want to show or Purgechar() to explicitely drop some characters from your string.
Have a look at the HELP page of both functions.
Will that work on just the one problem cell ?
Can you detail how your input file / data looks like or post a sample file?
So I tried it but it got rid of all the corresponding letters not just the phrase I needed removed
I am just guessing, but you probably want to remove some special characters like a LF character, so maybe try
LOAD
FIELD,
Purgechar(FIELD, chr(10)&chr(13) ) as FIELD_PURGED,
...
FROM ...;
I may just have to touch the data after all. Thank you for your help!