How to write the condition for to separate and create Q1-2020 from Submissions of Q1 2020 using subfield

[Vamsy1991]

Please help on to separate and create Q1 - 2020 from Submissions of Q1 2020 using subfield

Field name = Quarter

Quarter =Submissions of Q1 2020,Submissions of Q2 2020,Submissions of Q3 2020

Requirement =Q1 - 2020,Q2 - 2020,Q3 - 2020

[Chanty4u]

load *,
subfield(Quarter, ' ', -2) & '- ' & subfield(Quarter, ' ', -1) as NewQuarter;
load * Inline[
Quarter
Submissions of Q1 2020,
Submissions of Q2 2020,
Submissions of Q3 2020
];

exit SCRIPT;

[MayilVahanan]

Hi @Vamsy1991 

One more solution,

Replace(Right('Submissions of Q1 2020', 7), ' ','-') <--- Q1-2020

Load Replace(Right(Quarter, 7), ' ','-') as Quarter from ursource;

[Vamsy1991]

Thank you Chanty,

[Vamsy1991]

Thank you Mayilvahanan,