Good Morning everyone,

Forgive the simplicity of this question as I am new to Planet Press and currently working through the documentation provided when I have available time.

I am looking for a way to remove specific text from a data selection and I believe I can use strip( to do this but I was not able to successfully do this.

An example of the text within this data selection is: Quality - N (No Credit)

I would like to strip the (No Credit) out of this data selection when it appears anywhere within the selection.

Thank you in advance,

Mike Weber

You could do this using the 'strip' function.

In your data selection, click "Custom data selection" and type in the box:


...where 1 and 100 are the columns between which your data lies on the 'current line'.

Hope this helps.

Thanks for the response Jim,

I tried this but I get the following Result.

Result: PTK0039: "current.line" does not seem to be an interger variable.

Wildcard,

Did you put the "&" sign before "current"? It has to be there, otherwise it will not recognise it as a variable.

Regards,
Raphaël Lalonde Lefebvre

No more errors thankfully but why wont the rest of my data show up?

I am not sure what I am missing. No more errors are present, but the data selection is blank. My data selection is from line 15 to line 58, column 43 to 60. The function I have in there is this.



None of my data shows up with this function in place. If I change the &current.line to the actual line number it is located on, the function displays that line with the (No Cr stripped from it as intended. But none of the other lines are visable anymore.

I tweaked it a little bit to fit my data selection and it has to strip out '(No Cr' instead of (No Credit) I assume that I will be able to create several more functions to strip out other chunks of text as well?

You can't use &current.line on a data selection that contains multiple lines. As soon as you use an advanced expression, that expression operates on a single line.

Thankfully, there's an easy way to do this:

• Create a data selection that contains only the first item, on line 15
• Make sure you set it to custom data selection and use the strip command: =strip('(No Cr', @(&current.line, 43, 60))
• Go to the Repeat tab of your data selection object and set the From/To line fields to 15 and 58

Here, the advanced data selection will get "repeated" for each line in the From/To settings, incrementing the &current.line value as it goes.

That should do the trick.

Thank you Philippe! It is working as intended now.

Is there a way to add multiple items to this strip function? I thought I would be able to do something like this to strip out additional selections as well.

This is what I tried to do but it does not like this.



I tried adding a new function but it displays the data twice with the first column removing the (No Cr and the second removing the (Sales Adj

The end result I am looking for is preventing the following items showing up.

(Sales Adj
(Retur
(Sp.Li
(Salva
(Short
(Color
(No Cr

Sorry again for all the easy questions.

If you are trying to strip an already stripped string, you need two strip functions...



This will return "Stacey" which is my surname stripping out my first name, "James".

Thanks Jim! This has given me the desired result I wish to have.

No problem - glad I could be of assistance.