topic Re: Trim field value in QlikView

Trim field value

Meg00 — Wed, 01 Apr 2020 10:05:56 GMT

Hi!

I'm struggling finding the right combo of functions to get this right.

I want to trim my object Id field below to only present the actual object Id, so I wish to trim away the string "Document\".

The problem is this field contains a combination of "Document\[Object Id]" and just clean object Ids.

Does anyone have a suggestion on how to do this?

Re: Trim field value

piri1069 — Wed, 01 Apr 2020 11:48:12 GMT

Is "Document\" the only string you are stripping? If so, I would use the following in the load script:
If(WildMatch([Object Id],'Document\*'),Trim(Mid([Object Id],10,20)),[Object Id])

WildMatch([Object Id],'Document\*') - The Wildmatch function looks for 'Document\' in the row (I forget if '*' or '%' is the correct wildcard character)

Trim(Mid([Object Id],10,20)) - Mid function will let you get data from a designated character. Since 'Document\' is a known quantity, we can start the string after the last character. if the length of the following text is known, you could just put that quantity in placed the 20 characters i noted. I enclosed the script in a TRIM function to clean out any extra spaces .

hope this helps
Pedro

Re: Trim field value

Meg00 — Wed, 01 Apr 2020 12:46:50 GMT

Thank you, worked like a charm, also great explanation!

Re: Trim field value

yassinemhadhbi — Wed, 01 Apr 2020 13:11:23 GMT

Good Morning,

If i well understood your problem you probably need to

Right([Object Id],len([Object Id])-9)