Getting @ symbol when reading excel or word documents

[ppr (Peter Preuss)]

@Yankit_singh
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

but the @ 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:

Convert characters to ASCII code

@CamiCat [grafik] in short: 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: [grafik]