Hi,
I need to add a flag to certain files by adding a few words in the end of comment column.
For the column I am adding to -has difff lengths of dates, words, etc.
Ex of one:
Date(s) Received: 201912-22, 2027-03-17, 2020-03-29, 2000-06-01; Tranbaction Date(s): 2000-09-01, 2000-10-28, 2000-11-17, 2000-05-09;
I want to add a couple of words to end of it
is this possible maybe using a conditional statement if this colulmn has "" then add "comment etc etc" ?
I have 3 diff flags I need to input
thanks
Solved! Go to Solution.
I don't know what you're checking for to add the flags, but something like this:
IF Contains([Column],"Check1") THEN [Column]+"Flag1"
ELSEIF Contains([Column],"Check2") THEN [Column]+"Flag2"
ELSEIF ...
ELSE [Column]
ENDIF
Wait maybe I said it wrong but I need to add a few words if a column has that certain thing---how do I add words inside my column named comment?
What column are you checking for your condition? I assumed it was the same one you were adding comments to, and I've just called them both [Column] in the above. It will add your flag to the end of the existing text in the column, which I think is what you're trying to do? [Column]+"Flag" will return the existing contents of the column plus your flag.
No, if in the 'SamePOIAcctandTrl' columthen add the words "dup orig feed' to the end of the "comment" column
Is that a Boolean column?
IF [SamePOIAcctandTrl] THEN [comment]+" dup orig feed"
ELSE [comment]
ENDIF
You can add extra ELSEIF statements if you need them.
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |