Facing issue when using !ParseCSV command

weijielim — Wed, 18 Oct 2023 04:51:51 GMT

Hi guys, I am facing an issue when running !ParseCSV command as it is removing specific characters in a field value that is being displayed in the table output.

For example, my parsed CSV contains the following:

C:\Users\username_1\AppData\Roaming\Microsoft\Windows\Network Shortcuts\~$testing.xls

However, after running the command, it shows up in the table as

C:\Users\username_1\AppData\Roaming\Microsoft\Windows\Network Shortcuts~$testing.xls

Notice the difference is that it's missing a \ before ~ as shown in the second example.

Same issue here where the \ is missing before {.

Before: C:\ProgramData\Microsoft\ClickToRun\{XXX}\Microsoft_Office_Office Feature Updates.xml After: C:\ProgramData\Microsoft\ClickToRun{XXX}\Microsoft_Office_Office Feature Updates.xml

XSOAR version: 6.10.0 Build 187344 if that helps.

Re: Facing issue when using !ParseCSV command

mcooley — Mon, 23 Oct 2023 15:14:09 GMT

Hey @weijielim ,

I'd suggest opening a Support case for this issue. I was able to replicate the missing characters with ParseCSV on v6.12 using the examples you provided.

Re: Facing issue when using !ParseCSV command

weijielim — Tue, 24 Oct 2023 02:07:45 GMT

Thanks for looking into this, have opened a Support case.

topic Re: Facing issue when using !ParseCSV command in Cortex XSOAR Discussions

Facing issue when using !ParseCSV command

Re: Facing issue when using !ParseCSV command

Re: Facing issue when using !ParseCSV command