Convert string value from text source file to GUID [ERROR: Unrecognized Guid format]

[Doug Allinger 2]

I'm sure I'm missing something simple, but have been spinning on this for hours!

Objective:

Map string value retrieved from "text as source" file to valid GUID.

Example:

Value from text source file field TemplateGUID.val = 302d6d35-cbbf-ea11-a812-000d3a191efa

Tried:

psa_projecttemplate = guid(TemplateGUID.val)

ERROR:Unrecognized Guid format. StackTrace : at System.Guid.GuidResult.SetFailure(ParseFailureKind failure, String failureMessageID, Object failureMessageFormatArgument, String failureArgumentName, Exception innerException) at System.Guid.TryParseGuid(String g, GuidStyles flags, GuidResult& result) at System.Guid.Parse(String input) at Scribe.Process.ProcessWBSProjectTemplateDeliverables.Execute(Dictionary`2 settings, IEnumerable`1 dataEntityInput) : Error in mapping 'psa_projecttemplateitem.psa_projecttemplate ' for Operation 'Create' Error in mapping 'psa_projecttemplateitem.psa_projecttemplate ' for Operation 'Create'

psa_projecttemplate = "302d6d35-cbbf-ea11-a812-000d3a191efa"

Works

psa_projecttemplate = TemplateGUID.val

No error, but does not map.

What am I missing

[Ash Arendsz]

Could you try this

 

Add an IF Block to check for emptynull values:

IF Block: ISNULLOREMPTY(TRIM(mapped.value)) equals TRUE

ELSETRIM(mapped.value) to your guid.