Filter Stage error : Non-pipe (or non-virtual data set)

[vinaymanchinila]

hi,
In the filter stage when I use the condition

Col1='Sales #'

it gives the below error:

main_program: Data set, file set, or file "Copy_13:ToFilter.v": Non-pipe (or non-virtual data set) with .v in its name
Data set, file set, or file "Copy_of_FilterFlag:Lkup_Flag.v": Non-pipe (or non-virtual data set) with .v in its name

When I change the filter condition to Col1='Sales' with no '#' sign it works, is there a way I can go about it.

Thanks,

[ArndW]

What happens if you escape it as in \# ?

[prabu]

What happens if you escape it as in \# ? ...

you will hit bulls eye , i have checked it , it solves the problem

[vinaymanchinila]

Thanks guys !

[ray.wurlod]

The "#" sign is a special symbol in DataStage, a matched pair indicates a reference to a job parameter.