how to substr any character string which will consider all spaces and special characters in the fields.
I have to substr a field to 200 character which will consider all spaces and special characters in the sting.
Currently I just used length=200 for the field but it had created string with more than 200 length of characters by putting "" double quotes twice to the string as example below. I suppose I Need to use substr function to do this?
Example :
No wire activity was identified during an extended search from July-September 2018.
BAU All Trans report identified minimal activity; of note was a debit for $100K stating "OFAC/Funds moved to Omnibus". UAR# xxxx
"No wire activity was identified during an extended search from July-September 2018.
BAU All Trans report identified minimal activity; of note was a debit for $122K stating ""OFAC/Funds moved to Omnib"