Dear Forum members
In my word and excel document there is some date, when i am reading that word or excel documents then it automatically taking a "@ " symbol in front of the text of word or excel.
When i am splitting the text then it automatically putting “@” with any value.
After splitting :
Help me out.
Thankx in advance
we assume that you have split on space (blanks) otherwise may we ask to share some more details with us.
the meaning of
@ is that the string is handled as a
verbatim string literal . It means that escaping isn’t applied.
we do see some additional character (see yellow mark and line break)
after split we also do see that the
@ is moved to the part with the line breaking part
@ would not be part of the string content.However we suggest to find out what this “hidden” char is of type of.
May we ask for screenshot from watch panel for this string /split item
Also have a look here for an analysis for non displayed chars:
ASC - returns ASCII Code for a character
CHR - returns Character for an ASCII Code
last line filters out the characters not rated as wanted
So it depends on your definitions / allowed Ascii codes that you want to rate as valid
Maybe be used for some reports:
Thankx for response
I have split string on space base and getting this @ symbol.
as mentioned above the function on @ was introduced. May we ask you to go through again to the answer. Thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.