You are viewing limited content. For full access, please sign in.

Question

Question

Quickfield substitute query

Quick Fields Version 9 Capture

Updated December 24, 2013

asked on December 20, 2013

Dear LF Team

how to change following value using Quick field Substitution.

value : ABC<XYZ<TEST<<<<

i use \W and got the value :ABCXYZTEST

but i want the value like : ABC XYZ TEST

any idea how to do it ?

Thank You.

Best Regards

Mazahir Naya

0 0

Answer

APPROVED ANSWER

replied on December 23, 2013

Just replace the "<" character with a space. You may have to run the results through a pattern matching process to strip out the trailing spaces.

Or you could replace ([A-Z]+)<([A-Z]+)<([A-Z]+)<+ with ${1} ${2} ${3} (using match groups).

1 0

Replies

replied on December 23, 2013

Dear Miruna

Thank you very much for reply i solve the problem using Substitution

" [^ABCDEFGHIJKLMNOPQRSTUVWXYZ]" with Blank Space

Best Regards

Mazahir Naya

sub-space.jpg (68.96 KB)

| Download

0 0

replied on December 24, 2013

Yeah, that would work too. You could shorten it to [^A-Z] and it will have the same trailing spaces issue as my first suggestion.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.