FlowHeater - The Data Import / Export Specialist
See also the general examples available, which may answer your question: Hello World 1 / 2 / 3 , format numbers as character strings , simple If-Then-Else , complex If-Then-ElseIf , filtering and grouping data , consolidate grouped values

Net Script LIKE

  • JD Cox
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 3 months ago #3486 by JD Cox
Net Script LIKE was created by JD Cox
I know the problem is 'if (tag.contains(swholesale))', what can I do to make this work
//////////////////////////////////////////////////////////////////////////////////////////
public object DoWork()
{
//string value something like 'DANE, Supply Company, wholesale'
//i'm looking for the tag 'wholesale'

string tag = (string)InValues[0].GetString();
string swholesale = "wholesale";
int icid = 0;

if (tag.contains(swholesale))
{
icid = 205;
}
else
{
icid = 207;
}
return icid;
}

Please Log in or Create an account to join the conversation.

More
4 years 3 months ago - 4 years 3 months ago #3487 by FlowHeater-Team
Replied by FlowHeater-Team on topic Net Script LIKE
Hi JD,

you need the IndexOf method. Attached you´ll find a short example.

C# script example
Code:
public object DoWork() { string tag = (string)InValues[0].GetString(); string swholesale = "wholesale"; int icid = 0; // StringComparison.OrdinalIgnoreCase = ignore Upper/Lower case if (tag.IndexOf(swholesale, StringComparison.OrdinalIgnoreCase) >= 0) { icid = 205; } else { icid = 207; } return icid; }


File Attachment:

File Name: dotnet-indexof.zip
File Size:2 KB

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Attachments:
Last edit: 4 years 3 months ago by FlowHeater-Team.

Please Log in or Create an account to join the conversation.

  • JD Cox
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 3 months ago #3488 by JD Cox
Replied by JD Cox on topic Net Script LIKE
As always, Robert, thank you.
It works great, and thanks for adding in the ignore case.
They only have three tags for now that I manage with a stack of IfThenElses.
This is much easier to manage and cleaner.
Thanks, JD

Please Log in or Create an account to join the conversation.

Time to create page: 0.324 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2023 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en