Escape '$'-sign in Inline Load

[JustinDallas]

Hello Folks,

I'm doing an Inline Load and one of the values has a dollar sign in it.  How do I get QliKSense to not try to expand it?

Below is a demo:

[Test Table]:
Load * Inline
[
SomeField
Test Field 1
Awd Tot $(by CAN)
]
;

Exit Script
;

Which outputs this:

I'm expecting it to have Awd Tot $(by CAN) in it's place.

Any help is greatly appreciated

[SerhanKaraer · Accepted solution]

Hello Justin,

Just replace $( with another unique characters that you will replace later in the load statement.

[Test Table]:
Load Replace(SomeField,'###(','$'&'(') as SomeField Inline
[
SomeField
Test Field 1
Awd Tot ###(by CAN)
]
;
Exit Script
;

 I hope it resolves your issue.

[JustinDallas]

Following @SerhanKaraer 's advice, I replaced the dollar-sign with an @ since I know it will never appear in the fields.

[Test Table]:
Load Replace(SomeField,'@','$') as SomeField
;
Load * Inline
[
SomeField
Test Field 1
Awd Tot @(by CAN)
]
;

Exit Script
;